﻿CREATE proc capquyenxoaid  
@ID int  
as  
if(exists(select * from QuanTri_CapQuyenNguoiDungSuDungMenu Where ID=@ID))  
begin  
delete from QuanTri_EditUserRoleInGroup Where IDCapQuyen=@ID
delete from QuanTri_CapQuyenNguoiDungSuDungMenu Where ID=@ID  
select ErrCode=1  
end  
else  
begin  
select ErrCode=0  
end